CREATE TABLE [dbo].[Orders]
(
[ORDER_NUMBER] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Orders_ORDER_NUMBER] DEFAULT ((0)),
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ORG_CODE] DEFAULT (''),
[ORDER_TYPE_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ORDER_TYPE_CODE] DEFAULT (''),
[STAGE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_STAGE] DEFAULT (''),
[SOURCE_SYSTEM] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_SOURCE_SYSTEM] DEFAULT (''),
[BATCH_NUM] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_BATCH_NUM] DEFAULT (''),
[STATUS] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_STATUS] DEFAULT (''),
[HOLD_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_HOLD_CODE] DEFAULT (''),
[ORDER_DATE] [datetime] NULL,
[BT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_BT_ID] DEFAULT (''),
[ST_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ST_ID] DEFAULT (''),
[ST_ADDRESS_NUM] [int] NOT NULL CONSTRAINT [DF_Orders_ST_ADDRESS_NUM] DEFAULT ((0)),
[ENTERED_DATE_TIME] [datetime] NULL,
[ENTERED_BY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ENTERED_BY] DEFAULT (''),
[UPDATED_DATE_TIME] [datetime] NULL,
[UPDATED_BY] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_UPDATED_BY] DEFAULT (''),
[INVOICE_REFERENCE_NUM] [int] NOT NULL CONSTRAINT [DF_Orders_INVOICE_REFERENCE_NUM] DEFAULT ((0)),
[INVOICE_NUMBER] [int] NOT NULL CONSTRAINT [DF_Orders_INVOICE_NUMBER] DEFAULT ((0)),
[INVOICE_DATE] [datetime] NULL,
[NUMBER_LINES] [int] NOT NULL CONSTRAINT [DF_Orders_NUMBER_LINES] DEFAULT ((0)),
[FULL_NAME] [varchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_FULL_NAME] DEFAULT (''),
[TITLE] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_TITLE] DEFAULT (''),
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_COMPANY] DEFAULT (''),
[FULL_ADDRESS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_FULL_ADDRESS] DEFAULT (''),
[PREFIX] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_PREFIX] DEFAULT (''),
[FIRST_NAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_FIRST_NAME] DEFAULT (''),
[MIDDLE_NAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_MIDDLE_NAME] DEFAULT (''),
[LAST_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_LAST_NAME] DEFAULT (''),
[SUFFIX] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_SUFFIX] DEFAULT (''),
[DESIGNATION] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_DESIGNATION] DEFAULT (''),
[INFORMAL] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_INFORMAL] DEFAULT (''),
[LAST_FIRST] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_LAST_FIRST] DEFAULT (''),
[COMPANY_SORT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_COMPANY_SORT] DEFAULT (''),
[ADDRESS_1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ADDRESS_1] DEFAULT (''),
[ADDRESS_2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ADDRESS_2] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_STATE_PROVINCE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ZIP] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_COUNTRY] DEFAULT (''),
[DPB] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_DPB] DEFAULT (''),
[BAR_CODE] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_BAR_CODE] DEFAULT (''),
[ADDRESS_FORMAT] [tinyint] NOT NULL CONSTRAINT [DF_Orders_ADDRESS_FORMAT] DEFAULT ((0)),
[PHONE] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_PHONE] DEFAULT (''),
[FAX] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_FAX] DEFAULT (''),
[NOTES] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TOTAL_CHARGES] [money] NOT NULL CONSTRAINT [DF_Orders_TOTAL_CHARGES] DEFAULT ((0)),
[TOTAL_PAYMENTS] [money] NOT NULL CONSTRAINT [DF_Orders_TOTAL_PAYMENTS] DEFAULT ((0)),
[BALANCE] [money] NOT NULL CONSTRAINT [DF_Orders_BALANCE] DEFAULT ((0)),
[LINE_TOTAL] [money] NOT NULL CONSTRAINT [DF_Orders_LINE_TOTAL] DEFAULT ((0)),
[LINE_TAXABLE] [money] NOT NULL CONSTRAINT [DF_Orders_LINE_TAXABLE] DEFAULT ((0)),
[FREIGHT_1] [money] NOT NULL CONSTRAINT [DF_Orders_FREIGHT_1] DEFAULT ((0)),
[FREIGHT_2] [money] NOT NULL CONSTRAINT [DF_Orders_FREIGHT_2] DEFAULT ((0)),
[HANDLING_1] [money] NOT NULL CONSTRAINT [DF_Orders_HANDLING_1] DEFAULT ((0)),
[HANDLING_2] [money] NOT NULL CONSTRAINT [DF_Orders_HANDLING_2] DEFAULT ((0)),
[CANCELLATION_FEE] [money] NOT NULL CONSTRAINT [DF_Orders_CANCELLATION_FEE] DEFAULT ((0)),
[TAX_1] [money] NOT NULL CONSTRAINT [DF_Orders_TAX_1] DEFAULT ((0)),
[TAX_2] [money] NOT NULL CONSTRAINT [DF_Orders_TAX_2] DEFAULT ((0)),
[TAX_3] [money] NOT NULL CONSTRAINT [DF_Orders_TAX_3] DEFAULT ((0)),
[LINE_PAY] [money] NOT NULL CONSTRAINT [DF_Orders_LINE_PAY] DEFAULT ((0)),
[OTHER_PAY] [money] NOT NULL CONSTRAINT [DF_Orders_OTHER_PAY] DEFAULT ((0)),
[AR_PAY] [money] NOT NULL CONSTRAINT [DF_Orders_AR_PAY] DEFAULT ((0)),
[TAX_AUTHOR_1] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_TAX_AUTHOR_1] DEFAULT (''),
[TAX_AUTHOR_2] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_TAX_AUTHOR_2] DEFAULT (''),
[TAX_AUTHOR_3] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_TAX_AUTHOR_3] DEFAULT (''),
[TAX_RATE_1] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Orders_TAX_RATE_1] DEFAULT ((0)),
[TAX_RATE_2] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Orders_TAX_RATE_2] DEFAULT ((0)),
[TAX_RATE_3] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Orders_TAX_RATE_3] DEFAULT ((0)),
[TAX_EXEMPT] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_TAX_EXEMPT] DEFAULT (''),
[TERMS_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_TERMS_CODE] DEFAULT (''),
[SCHEDULED_DATE] [datetime] NULL,
[CONFIRMATION_DATE_TIME] [datetime] NULL,
[SHIP_PAPERS_DATE_TIME] [datetime] NULL,
[SHIPPED_DATE_TIME] [datetime] NULL,
[BO_RELEASED_DATE_TIME] [datetime] NULL,
[SOURCE_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_SOURCE_CODE] DEFAULT (''),
[SALESMAN] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_SALESMAN] DEFAULT (''),
[COMMISSION_RATE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Orders_COMMISSION_RATE] DEFAULT ((0)),
[DISCOUNT_RATE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Orders_DISCOUNT_RATE] DEFAULT ((0)),
[PRIORITY] [int] NOT NULL CONSTRAINT [DF_Orders_PRIORITY] DEFAULT ((0)),
[HOLD_COMMENT] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_HOLD_COMMENT] DEFAULT (''),
[AFFECT_INVENTORY] [bit] NOT NULL CONSTRAINT [DF_Orders_AFFECT_INVENTORY] DEFAULT ((0)),
[HOLD_FLAG] [bit] NOT NULL CONSTRAINT [DF_Orders_HOLD_FLAG] DEFAULT ((0)),
[CUSTOMER_REFERENCE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_CUSTOMER_REFERENCE] DEFAULT (''),
[VALUATION_BASIS] [tinyint] NOT NULL CONSTRAINT [DF_Orders_VALUATION_BASIS] DEFAULT ((0)),
[UNDISCOUNTED_TOTAL] [money] NOT NULL CONSTRAINT [DF_Orders_UNDISCOUNTED_TOTAL] DEFAULT ((0)),
[AUTO_CALC_HANDLING] [bit] NOT NULL CONSTRAINT [DF_Orders_AUTO_CALC_HANDLING] DEFAULT ((0)),
[AUTO_CALC_RESTOCKING] [bit] NOT NULL CONSTRAINT [DF_Orders_AUTO_CALC_RESTOCKING] DEFAULT ((0)),
[BACKORDERS] [tinyint] NOT NULL CONSTRAINT [DF_Orders_BACKORDERS] DEFAULT ((0)),
[MEMBER_TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_MEMBER_TYPE] DEFAULT (''),
[PAY_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_PAY_TYPE] DEFAULT (''),
[PAY_NUMBER] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_PAY_NUMBER] DEFAULT (''),
[CREDIT_CARD_EXPIRES] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_CREDIT_CARD_EXPIRES] DEFAULT (''),
[AUTHORIZE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_AUTHORIZE] DEFAULT (''),
[CREDIT_CARD_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_CREDIT_CARD_NAME] DEFAULT (''),
[BO_STATUS] [tinyint] NOT NULL CONSTRAINT [DF_Orders_BO_STATUS] DEFAULT ((0)),
[BO_RELEASE_DATE] [datetime] NULL,
[TOTAL_QUANTITY_ORDERED] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Orders_TOTAL_QUANTITY_ORDERED] DEFAULT ((0)),
[TOTAL_QUANTITY_BACKORDERED] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Orders_TOTAL_QUANTITY_BACKORDERED] DEFAULT ((0)),
[SHIP_METHOD] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_SHIP_METHOD] DEFAULT (''),
[TOTAL_WEIGHT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Orders_TOTAL_WEIGHT] DEFAULT ((0)),
[CASH_GL_ACCT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_CASH_GL_ACCT] DEFAULT (''),
[LINE_PST_TAXABLE] [money] NOT NULL CONSTRAINT [DF_Orders_LINE_PST_TAXABLE] DEFAULT ((0)),
[INTENT_TO_EDIT] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_INTENT_TO_EDIT] DEFAULT (''),
[PREPAID_INVOICE_REFERENCE_NUM] [int] NOT NULL CONSTRAINT [DF_Orders_PREPAID_INVOICE_REFERENCE_NUM] DEFAULT ((0)),
[AUTO_CALC_FREIGHT] [bit] NOT NULL CONSTRAINT [DF_Orders_AUTO_CALC_FREIGHT] DEFAULT ((0)),
[CO_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_CO_ID] DEFAULT (''),
[CO_MEMBER_TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_CO_MEMBER_TYPE] DEFAULT (''),
[EMAIL] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_EMAIL] DEFAULT (''),
[CRRT] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_CRRT] DEFAULT (''),
[ADDRESS_STATUS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ADDRESS_STATUS] DEFAULT (''),
[RECOGNIZED_CASH_AMOUNT] [money] NOT NULL CONSTRAINT [DF_Orders_RECOGNIZED_CASH_AMOUNT] DEFAULT ((0)),
[IS_FR_ORDER] [tinyint] NOT NULL CONSTRAINT [DF_Orders_IS_FR_ORDER] DEFAULT ((0)),
[VAT_TAX_CODE_FH] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ENCRYPT_PAY_NUMBER] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ENCRYPT_PAY_NUMBER] DEFAULT (''),
[ENCRYPT_CREDIT_CARD_EXPIRES] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ENCRYPT_CREDIT_CARD_EXPIRES] DEFAULT (''),
[AUTO_FREIGHT_TYPE] [tinyint] NOT NULL CONSTRAINT [DF_Orders_AUTO_FREIGHT_TYPE] DEFAULT ((0)),
[USE_MEMBER_PRICE] [bit] NOT NULL CONSTRAINT [DF_Orders_USE_MEMBER_PRICE] DEFAULT ((0)),
[ST_PRINT_COMPANY] [bit] NOT NULL CONSTRAINT [DF_Orders_ST_PRINT_COMPANY] DEFAULT ((0)),
[ST_PRINT_TITLE] [bit] NOT NULL CONSTRAINT [DF_Orders_ST_PRINT_TITLE] DEFAULT ((0)),
[TOLL_FREE] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_TOLL_FREE] DEFAULT (''),
[MAIL_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_MAIL_CODE] DEFAULT (''),
[ADDRESS_3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ADDRESS_3] DEFAULT (''),
[ENCRYPT_CSC] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ENCRYPT_CSC] DEFAULT (''),
[ISSUE_DATE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ISSUE_DATE] DEFAULT (''),
[ISSUE_NUMBER] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_ISSUE_NUMBER] DEFAULT (''),
[MORE_PAYMENTS] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Orders_MORE_PAYMENTS] DEFAULT ((0)),
[GATEWAY_REF] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_GATEWAY_REF] DEFAULT (''),
[ORIGINATING_TRANS_NUM] [int] NOT NULL CONSTRAINT [DF_Orders_ORIGINATING_TRANS_NUM] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED ([ORDER_NUMBER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrdersBT_ID] ON [dbo].[Orders] ([BT_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrdersCO_ID] ON [dbo].[Orders] ([CO_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrdersCOMPANY_SORT] ON [dbo].[Orders] ([COMPANY_SORT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrdersINVOICE_REF_NUM] ON [dbo].[Orders] ([INVOICE_REFERENCE_NUM]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrdersIS_FR_ORDER] ON [dbo].[Orders] ([IS_FR_ORDER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrdersLAST_FIRST] ON [dbo].[Orders] ([LAST_FIRST]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrdersST_ID] ON [dbo].[Orders] ([ST_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrdersSTAGE] ON [dbo].[Orders] ([STAGE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrdersSTATUS] ON [dbo].[Orders] ([STATUS]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Orders] TO [IMIS]
GRANT SELECT ON  [dbo].[Orders] TO [IMIS]
GRANT INSERT ON  [dbo].[Orders] TO [IMIS]
GRANT DELETE ON  [dbo].[Orders] TO [IMIS]
GRANT UPDATE ON  [dbo].[Orders] TO [IMIS]
GO